/*  1:   */ package gov.sat.tax.fwsk.util;
/*  2:   */ 
/*  3:   */ import java.io.PrintStream;
/*  4:   */ import java.sql.Connection;
/*  5:   */ import java.sql.PreparedStatement;
/*  6:   */ import java.sql.ResultSet;
/*  7:   */ 
/*  8:   */ public class GSFpSkFpHzDataBean
/*  9:   */ {
/* 10:   */   public int inSkFpHz(Connection conn, String p_sFpdm, String p_sFphm)
/* 11:   */   {
/* 12:19 */     int retvalue = -1;
/* 13:   */     
/* 14:21 */     String s_Sql = null;
/* 15:22 */     ResultSet resut = null;
/* 16:23 */     PreparedStatement stmt = null;
/* 17:   */     try
/* 18:   */     {
/* 19:26 */       s_Sql = 
/* 20:   */       
/* 21:   */ 
/* 22:29 */         "select swjg_dm from HTJS.FP_SKFP_HZ where fp_dm=" + p_sFpdm + " and fp_qs_hm<=" + Integer.valueOf(p_sFphm).toString() + " and fp_zz_hm>=" + Integer.valueOf(p_sFphm).toString();
/* 23:30 */       stmt = conn.prepareStatement(s_Sql, 1003, 
/* 24:31 */         1007);
/* 25:32 */       resut = stmt.executeQuery();
/* 26:33 */       if (resut.next()) {
/* 27:34 */         retvalue = 1;
/* 28:   */       } else {
/* 29:36 */         retvalue = 0;
/* 30:   */       }
/* 31:   */     }
/* 32:   */     catch (Exception theE)
/* 33:   */     {
/* 34:41 */       System.out.println(theE.getMessage());
/* 35:   */       try
/* 36:   */       {
/* 37:46 */         if (resut != null)
/* 38:   */         {
/* 39:47 */           resut.close();
/* 40:48 */           resut = null;
/* 41:   */         }
/* 42:50 */         if (stmt != null)
/* 43:   */         {
/* 44:51 */           stmt.close();
/* 45:52 */           stmt = null;
/* 46:   */         }
/* 47:   */       }
/* 48:   */       catch (Exception localException1) {}
/* 49:   */     }
/* 50:   */     finally
/* 51:   */     {
/* 52:   */       try
/* 53:   */       {
/* 54:46 */         if (resut != null)
/* 55:   */         {
/* 56:47 */           resut.close();
/* 57:48 */           resut = null;
/* 58:   */         }
/* 59:50 */         if (stmt != null)
/* 60:   */         {
/* 61:51 */           stmt.close();
/* 62:52 */           stmt = null;
/* 63:   */         }
/* 64:   */       }
/* 65:   */       catch (Exception localException2) {}
/* 66:   */     }
/* 67:59 */     return retvalue;
/* 68:   */   }
/* 69:   */ }


/* Location:           D:\htjs\document\wsrz\WsrzEjbInf\
 * Qualified Name:     gov.sat.tax.fwsk.util.GSFpSkFpHzDataBean
 * JD-Core Version:    0.7.0.1
 */